package sjd.ahsj.springbootmybatisplusoracle.mapper;

import com.baomidou.mybatisplus.mapper.Wrapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.session.RowBounds;
import sjd.ahsj.springbootmybatisplusoracle.entity.UserAmountBill;
import com.baomidou.mybatisplus.mapper.BaseMapper;

import java.util.List;

/**
 * <p>
 * 充值记录 Mapper 接口
 * </p>
 *
 * @author zhanghaogao
 * @since 2018-09-21
 */
public interface UserAmountBillMapper extends BaseMapper<UserAmountBill> {

    @Override
    @Select("select info.*,user.login_name as userName  ${ew.sqlSelect} from user_amount_bill as info left join " +
            "base_user as user on info.user_id=user.id where 1=1 ${ew.sqlSegment}")
    List<UserAmountBill> selectPage(RowBounds rowBounds, @Param("ew") Wrapper<UserAmountBill> wrapper);
}
